Krytpo Porto Status
JY
2021-10-31
Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- Download activity report.
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Cdn dollar value
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
Transactions & Adjusted Cost Base (Avg Cost)
Price, Costs, Profits
Cardano
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
Polkadot
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
Litecoin
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
TOTALS
| date | currency | book_val | market_val | profit | roi |
|---|---|---|---|---|---|
| 2021-10-31 | BTC | $3,177 | $5,047 | 1,870 | 59% |
| 2021-10-31 | ETH | $5,954 | $19,168 | 13,213 | 222% |
| 2021-10-31 | ADA | $4,495 | $3,764 | (731) | -16% |
| 2021-10-31 | DOT | $2,535 | $3,705 | 1,170 | 46% |
| 2021-10-31 | LTC | $2,305 | $2,391 | 86 | 4% |
| date | total_invested | total_market_val | total_profit | total_roi |
|---|---|---|---|---|
| 2021-10-31 | $18,466 | $34,075 | $15,608 | 85% |